Create database Admin2000
go
Use Admin2000
go

Create table Users
(
Uid int primary key identity ,
UserName nvarchar(20) not null ,
PassWord varchar(15) not null ,
IsActived bit default 1 ,
IsDeleted bit default 0,
CreateTime datetime default getdate() ,
UpdateTime datetime default getdate() ,
Remarks nvarchar(50) null

)

select * from Users 

insert into Users (UserName ,PassWord) values ('LuHan','123456')
insert into Users (UserName ,PassWord ,IsActived ,IsDeleted ) values ('LuYiHan','123456',0,0) ,('LuSan','123456',0,1)

